package com.bdqn.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bdqn.demo.pojo.SysUser;

/**
 * SysUserMapper
 *
 * @author f
 * @since 2021/11/25
 */
public interface SysUserMapper extends BaseMapper<SysUser> {
    // @Insert("INSERT INTO sys_user(usr_name,usr_password,usr_role_id,usr_flag) VALUES(#{usrName},#{usrPassword},#{usrRole},#{usrFlag})")
    // void insert(SysUser user);
    //
    // @Delete("DELETE FROM sys_user WHERE usr_id = #{id}")
    // void delete(Long id);
    //
    // @Update("update sys_user <set><if test=usrName != null>usr_name=#{usrName},</if><if test=usrPassword != null>usr_password=#{usrPassword},</if><if test=usrRoleId != null>usr_role_id=#{usrRoleId},</if><if test=usrFlag != null>usr_flag=#{usrFlag},</if></set>WHERE usr_id = #{usrId}")
    // void update(SysUser user);
    //
    // @Select("SELECT usr_id, usr_name, usr_password, usr_role_id, usr_flag FROM sys_user WHERE usr_id = #{id}")
    // @Results({@Result(column = "usr_id", property = "usrId"), @Result(column = "usr_name", property = "usrName"), @Result(column = "usr_password", property = "usrPassword"), @Result(column = "usr_role_id", property = "usrRoleId"), @Result(column = "usr_flag", property = "usrFlag")})
    // SysUser get(Long id);
    //
    //
    // @Select("SELECT usr_id, usr_name, usr_password, usr_role_id, usr_flag FROM sys_user")
    // @Results({@Result(column = "usr_id", property = "usrId"), @Result(column = "usr_name", property = "usrName"), @Result(column = "usr_password", property = "usrPassword"), @Result(column = "usr_role_id", property = "usrRoleId"), @Result(column = "usr_flag", property = "usrFlag")})
    // List<SysUser> findAll();
}
